Margin on Recent Receipts
Lists recent receipts by PO Number showing Quantity Received, Unit Cost, Unit Price and Gross Margin % for each item.
Access |
Grant permission to User Profiles in Access User Profiles > select a User Profile > Menu Security > Reports module > Main Menu > Purchasing |
Grant permission to the individual report > Purchasing > Margin on Recent Receipts |
Create Your Report
Select GM%Gross Margin percentage to focus the report on the Gross Margin Percentage entered. Use an operators to indicate if the Gross Margin Percent will be
- Greater than or equal to
- Less than or equal to
- Equal to
- Not equal to
Create a date range using Date Selection. To select an individual day, select the same date in the Start and End Date fields.
- Start Date- Enter a Start Date using the available drop down calendar or enter using the mm/dd/yy date format.
- End Date- Enter an End Date using the available drop down calendar or enter using the mm/dd/yy date format.
In Location Selection, all Locations selected by default. Select One Location and enter the Site ID or select F12 to search.
Select Preview to view the report onscreen.
Select Print to send the report directly to the default printer.

Understanding Your Report
The PO Number field displays the Purchase Order Number and Vendor name.
Item ID and item Description from the received PO
Quantity Received indicates the Quantity received for the Purchase Order
The Unit Cost of the item which is the replacement cost per stocking unit of measure plus freight.
The current Level 1 Price for a stocking unit of measure.
GM% displays the Gross Margin Percentage for the item as calculated (L1 Price - Unit Cost) / L1 Price